Vendors
The Vendors section is used to create and modify Vendor records as well as Vendor parts and pricing. Vendor records contain several order default fields which provide the default values when the Vendor is selected during Purchase Order entry. These defaults may be overridden by users as necessary. Vendor parts and pricing are optional tools that can be used to automatically populate the Vendor's Part Number and Purchase Price when using certain Vendors for purchasing specific parts. Vendor parts may also contain their own lead times and minimal Purchase Order quantities. In addition, the system will evaluate Vendor parts and pricing when using the Optimize prices feature within MRP.
System Navigation
- Purchasing > Vendors
Vendors pre-filter
Field |
Description |
---|---|
Report Type |
Pick list used to choose the desired kind of report that will generate. Options are:
Users with permission can create unlimited user versions of any vendor report and also determine which reports each user will see in this field. |
Vendor |
Search field used to select a specific Vendor. |
Vendor Group |
Search field used to select a Vendor Group. |
Facility |
Search field used to select a specific Facility. If selected, only records belonging to this Facility will be displayed. |
Facility Group |
Search field used to select a Facility Group. If selected, only records belonging to this Facility Group will be displayed. |
Search 1-2 |
Ability to filter the report based on the user-defined values in the PO Search 1-2 fields. |
Broker |
Used to select the default Broker for this Vendor when entering new orders. Enabled for both Vendors and Items Supplied Reports. |
Terms |
Search field used to select a specific Payment Term. If selected, only records with this specific payment term will be displayed. |
AP Account |
Search field used to filter the list of records by the "AP Account" assigned on the Order Defaults tab of the Vendor master record. |
Currency |
Search field used to select a specific Currency. If selected, only records with this Currency defined will be displayed. |
Work Flow Type |
Search field used to select a specific Type of Work Flow. If selected, only records with this Work Flow Type will be displayed. |
Sequence |
Search field used to select a specific Sequence or step in a Work Flow. |
Part Number |
Only available for use when running a "Report Type" of "Items Supplied". If selected, only Vendor parts for this specific Part Number, as defined in Item Master will be displayed. |
Part Starts With |
Only available for use when running a "Report Type" of "Items Supplied". If a value is entered, only Vendor parts that begin with the value entered for this specific Part Number will be displayed. |
Vendor Part Facility |
Only available when using a report type of "Items Supplied". Allows the ability to filter the information on the Items Supplied report by the Facility indicated on the Vendor Part form. |
PO Type |
Pick list used to display Vendors depending on the "PO Type" selected. Additional information regarding PO Type is located in the Order Defaults tab section below.
|
Display |
Pick list used to display Active, Inactive, or All records. |
Available To |
Option to include Vendor records that do not have a default Facility assigned. Options are None and All Users. This field is only available for users that have a Facility Restriction assigned. |
Expired Prices |
Only available for use when running a "Report Type" of "Items Supplied". Pick list used to hide or display Vendor parts that have expired prices. |
Items Supplied report
Opened via running a "Report Type" of "Items Supplied" on the Vendors pre-filter.
Field |
Description |
---|---|
Vendor |
Indicates the Vendor that is linked to the Part and for which the prices and quantities are valid. |
Facility |
Facility for which the pricing details are valid. |
Vendor Part |
Indicates the Vendor-specific version of the Part Number. |
Vendor Description |
Indicates the Vendor-specific description for the Part. |
Our Part |
Part Number as it appears on the Item Master. |
Vendor Unit |
The units in which the Vendor Part will be purchased. This allows material to be stocked by one unit, but purchased by another unit. |
Stock Unit |
The "Stock Unit" defined on the General 1 tab of the Part's Item Master. |
Units Per |
Displays the number of Stock Units per one Vendor Unit. For example, if the "Stock Unit" is set to pound and the "Vendor Unit" is set to kilogram, the "Units Per" would be 2.2046. |
QC Expires |
Indicates the date up until which the QC group selected on the record will be valid for this Vendor part. If the Deacom Part Number associated with the Vendor Part contains a QC Group, then this group will be used after the Qualified Until date when performing quality control. |
Price |
The price that will populate when entering new Purchase Orders for this Vendor and Part. |
Quantity |
Defines the minimum quantity that must be entered on Purchase Orders before the Price will be applicable. |
Start |
Earliest date that the specified Price will be considered. |
End |
Latest date that the specified Price will be considered. |
Edit Vendor Info form
Opened via the "Modify" button on the Items Supplied report. The top section of this form contains the Deacom Part Number, Description, Stock Unit, and the Vendor for which a Vendor-specific Part will be created. The majority of information on the Vendor Part record is available for printing on the purchasing forms and reports throughout the system. This form also contains options for specific pricing options and QC testing specifications for the selected Vendor Part.
Note that if Vendor-specific parts exist, and the Vendor and Part are selected when entering a Purchase Order, the system will use the information on the Vendor part record rather than the Part's Item Master record.
Vendors report
Opened via running a "Report Type" of "Vendors" on the Vendors pre-filter.
Field |
Description |
---|---|
Name |
Name of the Vendor |
Street |
Street on which the Vendor is located. |
City |
City in which the Vendor is located. |
State |
State in which the Vendor is located. |
Zip |
Zipcode for the Vendor's address. |
Contact |
Name of principal contact at Vendor’s order from address. |
Phone |
Contact’s telephone number. |
Edit Vendor form
Opened via the "New" or "Modify" buttons on the Vendors report. The top section of this form contains the Primary Contact information and buttons to do things like view Parts or Contacts connected to or details and history of the selected Vendor.
Field/Button |
Description |
---|---|
View Contacts |
If clicked, displays a list of Contacts for this Vendor. |
History |
If clicked, displays an Order History for the Vendor, which contains a summary of Vendor statistics such as AP aging totals, last payment date and amount, total of non-received purchase orders, Days AP outstanding, and additional Vendor payment information. |
Items Supplied |
If clicked, provides a list of Parts which this Vendor supplies. Existing records may be maintained here, allowing easy input of Vendor price changes. New records must be added through Item Master. |
A/P Ledger |
If clicked, displays the AP ledger report, listing all invoices and payments to this Vendor, and the resulting AP balance. The "View Detail" button on this report allows detailed viewing of each invoice or payment. |
Vendor |
Name of the Vendor, which must be unique. |
Primary Contact |
Name of principal contact at Vendor’s order from address. |
Phone |
Contact’s telephone number. |
Extension |
Contact’s telephone extension. |
General tab
Field/Flag |
Description |
---|---|
Vendor Number |
Automatically system-generated number. |
Street 1-3 |
Vendor street address to order from. Purchase Orders will be sent to this address. |
City, State, Zip |
Address details of Vendor to order from. |
Country, County |
Country and County of Vendor address to order from. |
Country Code |
Search field to select a phone mask if required. Masks for the country code may be managed via System > Maintenance > Country Codes. |
Fax |
Contact’s facsimile machine number. |
|
Email address of principal contact. Used when printing various reports, like Purchase Orders, to email. Email is addressed to the Contact, at the Email address. Multiple emails can be specified, separated by semicolons. |
Social Security # |
Social Security Number, used when printing 1099 forms. |
Taxpayer ID |
Taxpayer ID number for the Vendor company. |
VAT ID |
VAT ID number for the Vendor company, optional field. Required for EU users. |
Approval Expires |
Optional. Defines an expiration date that is evaluated when receiving inventory lots on PO lines for Vendor Part Cross Reference parts for this Vendor.
|
Notes |
Memo field used to provide additional details regarding this Vendor. Notes are available for printing on various purchasing reports throughout Deacom. |
Mobile Group |
Search field used to add this Vendor to a mobile access group. Mobile access groups allow users to view Vendor and Purchase Order reports via the use of portable devices such as cell phones and tablets. Additional information is available via System > Maintenance > Published Data. |
Order Pop-Up Notes |
Any notes entered into this memo field will pop up onto the user’s screen whenever this Vendor is selected on a Purchase Order. |
Receiving Pop-Up Notes |
Any notes entered into this memo field will pop up onto the user’s screen whenever the Purchase Orders for this Vendor are received. |
ID |
ID for the Vendor. |
Retain QC |
Pick list used in conjunction with the "Copy Vendor/Pre Production QC" flag on QC Groups which allows users to stipulate that QC results that have already been entered for a lot will be applied to all lots of Parts received from the Vendor going forward, but only when receiving for the same User Lot for the Part(s) on which the original QC results were performed. Specifically, the functionality looks for when a User Lot is received that matches an existing User Lot in inventory (received from the same Vendor) that is the Same Part or for All Parts. Options are:
Notes:
|
Unit of Measure |
Used in connection with the "Minimum Unit" field below. Search field used to indicate the Unit of Measure that will be used when calculating the minimum unit quantity or weight below. This is a weight calculation. For example, assume the Unit of Measure in this field is "Pounds". Next, assume that a Purchase Order for this Vendor contains multiple line items. Some line items are specified with a Unit of Measure of "Pounds" and others are specified with a Unit of Measure of "Eaches". When saving the order, the system will check the "Unit Weight" field on the Calcs tab of all items on the order, including the items specified in "Eaches", in order to determine the total weight of the order. The system will then compare this total to the value in the "Minimum Unit" field below. Only stocked items are considered in the calculation. |
Minimum Unit |
Indicates the minimum order quantity/size, in the Unit of Measure specified in the above field, that must be ordered on a Purchase Order for this Vendor. Users with the security setting "Purchase Orders -- create PO less than minimum size" may override the minimum. Users without this access will receive a prompt when trying to save a Purchase Order that does not meet the minimum and the system will automatically change the "Order Type" to "Requisition". Values of 0 are ignored when performing checks. |
Minimum Extension |
Indicates the minimum total order extension or amount that must be entered on a Purchase Order for this Vendor. Users with the security setting "Purchase Orders -- create PO less than minimum extension" may override the minimum. Users without this access will receive a prompt when trying to save a Purchase Order that does not meet the minimum. Values of 0 are ignored when performing checks. This check is also applied when using the Order Adjustments function. |
Vendor Group |
Search box available to select a Vendor Group. In situations where Vendors share the same remittance information, Vendor Groups can be used to pay multiple Vendors with one check. If Vendors are assigned the same Vendor Group, the system will group the invoices belonging to the same Vendor Group and pay the associated invoices on the same check.
|
Language |
Search field used to have a specific Language set for this Vendor. This option, which is only available in web versions, is useful in situations where captions on documents for Vendors or customers will be different than the Language assigned to specific Users. |
Default Payment Type |
Option to specify a Payment Type which can be used to filter orders for this vendor when producing manual checks or performing check runs.
|
Accept Backorders |
When receiving less than what is ordered on a Purchase Order to this Vendor, this flag indicates if a backorder may be created for the materials not received.
|
Available To All Users |
If checked, all Users will be able to select this Vendor during Purchase Order entry, regardless of the Facility selected on the Vendor record and any Facility restrictions the User may have. For example, if the following Vendors and Users are setup:
Then:
|
Take Discounts |
When entering invoices for this Vendor, this flag indicates if Terms discounts are taken by default. If discounts are taken, the "Cash Discount" is automatically calculated, and the "Date to Pay" is set to the last day that the discount is available to be taken. |
Take Discounts On Freight |
If checked, indicates that discounts will be applied to the freight amount on Purchase Orders for this Vendor. |
Auto Invoice |
If checked, the Vendor invoice will be automatically created upon receipt of material against Purchase Order.
|
Active |
If checked, this record is active. Inactive Vendors cannot be ordered from, invoiced, have payments applied, or otherwise be used in the application, but their historical records are kept. |
EDI (requires ECI license) |
Indicates that the Vendor uses EDI, for use in custom EDI applications. |
Require Vendor Lot Date |
Indicates that a lot date is required when receiving material from this Vendor. |
Require Manufacturing Vendor |
If checked, will make indicate that the "Manufacturing Vendor" field on the Edit Purchase Order Line form is required when selecting this Vendor.
|
Schedule MRP POs From Job Routings |
This flag, for use in web versions only, provides the option to have Purchase Orders created from MRP split out based on when the materials (usually raw materials) will be needed during the production process. This would allow for a better just-in-time delivery process and is useful for Jobs that may run for several days. The Routing in the Deacom system is the ideal mechanism to specify when raw materials will be needed. If this flag is checked, the system will check the Routing on the Job linked to the Purchase Order(s) created to satisfy the Job requirements in MRP and create Purchase Orders based on the quantity specified for the Routing step. |
Retain Attribute 1-3 |
If checked, during PO receipt for this Vendor, the system will copy over the attributes if the receiving user lot has been received prior. For example, if these flags are checked on the Vendor record, during receipt from this Vendor, a User Lot named "test123" is created and three unique attributes are entered. A week later, another lot is received from this Vendor and the User Lot "test123" is entered. The system will query the system and vendor records, recognize that these "Retain Attribute" flags are checked and will pull them into the record for the new lot. For additional ease of use, these flags may be used in connection with the "Lot # Expression" field available on the Purchasing tab in System > Options. |
Retain Lot and Expiration Dates |
If checked, during PO receipt for this Vendor, the system will copy over the Lot and Expiration Dates if the receiving user lot has been received prior. |
Require Unique Invoice Number |
If checked, users must enter a unique invoice number in Deacom for each invoice received from this Vendor. If left unchecked, the system will display a prompt indicating that the invoice number is the same, but the user will be allowed to accept the prompt and proceed with entering a duplicate invoice number. |
Remit To tab
Each Vendor may have Remit To information entered, which is printed on checks.
Field |
Description |
---|---|
Remit To Name |
Vendor’s remit to name. Used on both the Check Address line and the Pay to the Order of line, if present. If this field is empty, the information on the General tab of the Vendor record is used to print on checks. |
Street 1-3 |
Street address of remit to location. |
City, State, Zip, Country |
City, State, Zipcode, and Country of remit to location. |
Contact |
Name of principal contact at remit to location. |
Phone |
Telephone number of principal contact at remit to location. |
Extension |
Telephone extension of principal contact at remit to location. |
Fax |
Facsimile machine number at remit to location. |
|
E-mail address of principal contact at remit to location. |
Order Defaults tab
Field/Flag |
Description |
---|---|
Default Invoice |
If the Vendor’s Invoice Number or Account Number for the company's account remains the same from one invoice to the next, it can be entered here to reduce data entry for AP during vendor invoice entry. |
Purchase To Account |
Used to specify the expense account to which service costs/utilities are posted when this Vendor is selected on a Purchase Order. |
AP Account |
Liability account to which Purchase Order receipts are credited and payments to Vendors are debited.
|
AP Suspense |
Liability account to which Purchase Order receipts are credited (rather than the "AP" account).
|
Facility |
Select the Facility that this Vendor usually supplies, which will be used as the default on all of this Vendor’s Purchase Orders. This is not a required field for Vendors, but is required on Purchase Orders. If the Vendor equally supplies all Facilities, leave this blank to force the proper selection when entering Purchase Orders. |
Terms |
Used to select the default Payment Terms for this Vendor when entering new orders. |
Freight Type |
Used to select the default Freight Type for this Vendor when entering new orders. |
Ship Via |
Used to select the default Ship Via code for this Vendor when entering new orders. |
Broker |
Used to select the default Broker for this Vendor when entering new orders. |
Search 1-2 |
Used to select the default user-defined search box data for this Vendor when entering new orders. The two user-defined purchasing search boxes allow Vendors and Purchase Orders to be categorized for analysis and/or processing. If a search box is used to identify which purchasing agent is assigned to the Vendor, then the purchasing agents can each create a list of which open Purchase Orders and/or backorders exist for “their” Vendors. If some Vendors are paid monthly, and some paid weekly, use of the search box as a filter in check printing allows the correct Vendors to be paid in each Check Run. The captions for these search boxes are modifiable on the Purchasing tab of System > Options and the pick list options are managed via Purchasing > Maintenance > (Caption Name). |
Currency |
Used to select the native Currency that this Vendor’s Purchase Orders should be written in. |
Default Contact |
Used to select a default Contact from the list in the CRM Reporting section of Deacom. |
Default Work Flow |
Used to assign a default Work Flow that will be used when entering a Purchase Order for this Vendor. Work Flows are used to provide tracking of company approval processes and can be configured in a variety of ways depending on a company's requirements. |
Print Substitutions |
Searchbox to select any active Print Substitution Groups if applicable to the vendor. |
PO Type |
Pick list used to determine which Purchase Orders users are allowed to view. The option to mark orders as Private is useful in situations where certain orders, such as those dealing with monthly rent or equity payments, should only be viewed by accounting personnel. Options are:
|
Pricing Based On |
Pick list used to select which date (on the Dates tab of a Purchase Order) the system will use when determining how pricing will be based for orders to this specific Vendor. Options are:
PO Date 3 is used as the Due to Dock date for MRP purposes. One use case for this option is situations in which companies purchase long lead time items and the Vendor bases their blanket prices on when the item is due to dock rather than when the order was placed. For example, there are two blanket Purchase Orders, one with a release date of 11/1 with an expiration of 11/30 and a price of 1.00 USD, and a second with a release date of 12/1 with an expiration of 12/31 and a price of 2.00 USD. On Vendor A, the "Pricing Based On" date is set to "Order Date". If a Purchase Order is created for the Vendor with an Order Date of 11/20 and a Due to Dock date of 12/1, the price for items added to the PO will be 1.00 USD. Instead, if the "Pricing Based On" for the same Vendor is set to "Due To Dock (MRP)" (which is the "PO Date 3" setting) and the same Purchase Order is created with an Order Date of 11/20 and Due to Dock date of 12/1, the price for items added to the Purchase Order will be 2.00 USD. |
Document Group |
Option to select a Document Group for this Vendor. This provides the default value for the Document Group on purchase orders created with this Vendor.
|
1099 Type |
Combobox to select the 1099 Type the user needs according to IRS guidelines when printing. The options are as follows:
|
1099 Form Type |
Search field used to select a 1099 Form Type, which is used to determine which 1099 box the Purchase Order amount should be included on.
|
1099 Required |
If checked, the "1099 Required" flag will be checked by default on the Misc 2 tab of new Purchase Orders for this Vendor.
|
Restrict Link to POs To Sames Vendor |
If unchecked, users will be able to select from any existing PO, and not just POs for this Vendor, when using the Link to PO search box on the Purchase Order Entry from. This field is checked by default when adding a new Vendor record in the system. One possible use for un-checking this flag is when a PO for freight charges exists and will be used to link to POs for various Vendors. |
User Fields tab
Deacom allows the creation of user-defined fields that, once created, are available on various master data records such as items, Vendors, and Ship-to Companies. These fields allow companies to enter and store information outside of the fields provided in the system. The user fields on the Vendor record may be used to capture information such as Number of Employees. User fields may be added via Tools > Maintenance > User Fields.
Work Flow tab
The Work Flow tab displays the Work Flow assigned to the Vendor record and the associated Sequences that must be completed before the master record is considered complete. For more information on the fields, refer to the Edit Work Flow Sequence form section of the Work Flow Reporting Encyclopedia page
When selecting a new Vendor on a Purchase Order, if the Vendor has no Purchase Order Work Flow or the same Purchase Order Work Flow as the current one on the order, the Work Flow will not reset. This is useful in situations where orders are entered without a known source (Vendor), but Work Flow approvals or Sequences have been completed on the order. In this situation, having the Work Flow not re-fire ensures the approvals are not erased.
Facilities tab
Introduced in version 16.02, the Facilities tab allows users to set Facility specific order defaults by Vendor. These Facility specific defaults will be used, and not the defaults on the Order Defaults tab, when the specified Facility is selected for this Vendor during Purchase Order entry. This also applies to Purchase Orders created from within MRP. Useful in situations where companies have different purchasing requirements based on the facility that is ordering goods or services.
Facility and Facility Group restrictions are applied on the Vendor Facilities tab. If restricted to a Facility Group, a user will only be able to see and modify entries for Facilities in the restricted Facility Group. The same holds true for Facilities. If a user is restricted to a Facility, they will only be able to see and modify the entry for the Facility to which the user is restricted. Note also that security exists to control the ability to add or modify records on the Facilities tab.
Related Note: Beginning in version 17.01.006, Facility and order type (sales or purchase order) restrictions can be defined for Ship Via Methods. See the Edit Ship Via Facilities section for additional information.
GL Overrides tab
GL overrides by Vendor is the behavior where purchasing transactions (like receiving or invoicing Purchase Orders) can override the GL code affected, based on the Vendor on the transaction. This allows different groups of Vendors, or even every individual Vendor, to use different GL codes for revenue, COGS, and A/R, if desired.
Tax Regions tab
The Tax Regions tab is used to establish regions where purchases from this Vendor are normally taxable. The Tax Regions set here serve as the default Tax Regions that will be populated when entering Purchase Orders for this Vendor. Tax Regions are maintained via Accounting > Maintenance > Tax Regions. Users may modify or remove the default Tax Regions on orders as required.